home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Assistant
/
Business Assistant.iso
/
indus
/
splus1
/
merge.doc
< prev
next >
Wrap
Text File
|
1988-10-09
|
5KB
|
124 lines
WordStar/MailMerge[TM]/Basica/Output Sequential File
[also: WordPerfect[TM] Merge and dBASE III [TM] ]
OVERVIEW
Thesσ option≤ creatσ eithe≥ ß WordStar/MailMerge[TM]¼á WordPerfect[TM]¼á o≥ ì
dBAS┼á II╔á [TM▌ datß filσ usinτ thσ datß froφ you≥ Maste≥á File/dBAS┼á II╔ ì
file« Thσ newl∙ createΣ filσ end≤ iε thσ letters║ '.DAT'¼ '.SFº o≥ '.DBF'.
Iµ useΣ witΦ Wordstar[TM]¼á thσ .DA╘ filσ caε bσ useΣ t∩ prin⌠ forφ letter≤ ì
iε MailMerge[TM]«á Al∞ characte≥ field≤ arσ trimmeΣ oµ trailinτ blank≤ t∩ ì
accommodatσá you≥ forφ letters«á Alonτ witΦ thi≤ datß file¼á thσ Wordsta≥ ì
optioεá create≤á thσ beginninτ oµ you≥ forφ lette≥ anΣ put≤ i⌠ iεá ßá filσ ì
endinτá iε thσ │ letter≤ '.DEFº (containinτ al∞ thσ MailMerge[TM▌á command≤ ì
yo⌡ neeΣ a⌠ thσ star⌠ oµ ß forφ letter)«
Iµá useΣ witΦ WordPerfect[TM]¼á thσ .S╞ filσ i≤ thσ 'Secondar∙á Fileºá tha⌠ ì
WordPerfec⌠á use≤á fo≥ mergσ letters¼á wherσ eacΦ fielΣ i≤ delimiteΣá witΦ ì
CONTROL-R¼ anΣ eacΦ recorΣ i≤ delimiteΣ witΦ CONTROL-E.]
Iµ useΣ witΦ dBAS┼ II╔ [TM]¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ß standarΣ ì
datßá filσ forma⌠ tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥á thei≥á respectivσ ì
datß impor⌠ function.
Thesσá option≤á wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iεá you≥á prospec⌠ ì
filσá t∩á aεá externa∞á tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣá b∙á ßá worΣ ì
processo≥ t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.
BaseΣá oε you≥ selectioε criteria¼á iµ any¼á thσ prograφ wil∞ outpu⌠á thesσ ì
fields║
Primar∙ ID¼ Secondar∙ ID¼ 3rΣ ID¼ Comment≤
==============
| OPTION 1: |
==============
Selection Process:
A⌠ optioε 1¼ yo⌡ caε inpu⌠ u≡ t∩ ╖ searcΦ criteriß a≤ thσ basi≤ fo≥
you≥ worΣ processo≥ mergσ file║
Primary ID, Secondary ID, 3rd ID, Comment≤
Yo⌡á caε selec⌠ whethe≥ yo⌡ wan⌠ onl∙ thosσ record≤ t∩ bσ selecteΣá tha⌠ ì
havσá al∞ oµ criteriß iε ever∙ recorΣ o≥ selec⌠ ou⌠ record≤ regardles≤á oµ ì
thσ numbe≥ oµ matche≤ madσ pe≥ record¼á a≤ lonτ a≤ a⌠ leas⌠ onσ matcΦ i≤ ì
madσ iε an∙ onσ recorΣ tha⌠ i≤ selected.
Truσ [o≥ T▌ mean≤ al∞ matche≤ havσ t∩ bσ madσ iε an∙ onσ recorΣ fo≥ i⌠ t∩
bσ selected« Falsσ [o≥ F▌ mean≤ tha⌠ a≤ lonτ a≤ onσ matcΦ i≤ madσ iε ß
recorΣ i⌠ wil∞ bσ selected.
è Search Criteria Selection:
Option 1:
Yo⌡ caε ente≥ an∙ word¼á phrase¼ o≥ codσ oε whicΦ t∩ basσ you≥ selection« ì
Iµá lef⌠ blank¼á al∞ record≤ wil∞ bσ selecteΣ out«á Iµ yo⌡ makσ aεá entr∙ ì
here¼á thσá prograφ wil∞ searcΦ througΦ thσ prospec⌠ filσ anΣ selec⌠á ou⌠ ì
onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.
[Notσ tha⌠ yo⌡ caε havσ u≡ t∩ ╖ differen⌠ code≤ o≥ phrase≤ entereΣ herσá anΣ ì
al∞á record≤ wil∞ bσ pulleΣ whicΦ havσ an∙ onσ oµ theφ o≥ an∙ combinatioε ì
oµ them]
==============
| OPTION 2: |
==============
2) Output records to Wordstar/Mailmerge[TM]
Thi≤á optioε i≤ useΣ t∩ ge⌠ datß froφ thσ Master File filσ anΣ outpu⌠ i⌠á t∩á ß ì
filσá tha⌠á caε bσ useΣ b∙ WordStar/MailMerge[TM]«á Thi≤ filσ caε als∩á bσ ì
useΣ b∙ BASI├ anΣ othe≥ language≤ anΣ products«á Iε short¼á an∙ produc⌠ tha⌠ ì
accept≤á "commß delimitedó file≤ fo≥ inpu⌠ ma∙ accep⌠ thσ filσá createΣá b∙ ì
thi≤ option.
Froφ thσ WordSta≥ option¼á yo⌡ wil∞ creatσ tw∩ files« Thσ firs⌠ filσ namσ ì
end≤á iε .DE╞ anΣ i≤ ß filσ tha⌠ caε bσ turneΣ int∩ ß forφ lette≥á jus⌠á b∙ ì
callinτ i⌠ u≡ iε WordSta≥ anΣ matchinτ i⌠ t∩ you≥ forφ letter«á I⌠ alread∙ ì
contain≤á al∞á oµá thσá command≤á needeΣ b∙ WordSta≥á t∩á reaΣá thσá Maste≥ ì
File/dBAS┼ II╔ datß filσ (.DAT).
Thσ othe≥ filσ i≤ thσ .DA╘ file¼á whicΦ contain≤ al∞ datß tha⌠ yo⌡ wan⌠ t∩ ì
reaΣ int∩ WordStar«á I⌠ i≤ formatteΣ sequentia∞ file¼á witΦ al∞ field≤á iε ì
quote≤ anΣ separateΣ b∙ commas«
==============
ⁿ OPTIO╬ 3║ |
==============
3) Output records to WordPerfect[TM]
Thσá .S╞á filσá i≤á thσ 'Secondar∙ Fileº tha⌠ WordPerfec⌠á use≤á fo≥á mergσ ì
letters¼á wherσ eacΦ fielΣ i≤ delimiteΣ witΦ CONTROL-R¼á anΣ eacΦ recorΣ i≤ ì
delimiteΣ witΦ CONTROL-E.]
==============
| OPTION 4: |
==============
4) Output records to dBASE III [Registered TM]
WitΦá optioεá 4¼á thσ '.DBFº filσ forma⌠ i≤ becominτ ßá standarΣá datßá filσ ì
forma⌠á tha⌠ man∙ othe≥ program≤ arσ usinτ fo≥ thei≥ respectivσ datßá impor⌠ ìèfunction«
Oncσá yo⌡ assigε ß namσ t∩ thσ dBAS┼ II╔ [TM▌ filσ yo⌡ arσá outputting¼á thσ ì
structurσ oµ tha⌠ filσ is:
Field Field Name Type Width Dec
1 FNAME Character 20 <======== 3rd ID
2 LNAME Character 20 <======== 2nd ID
3 PROSPECT Character 40 <======== Primary ID
4 COMMENT1 Character 60
5 COMMENT2 Character 60
** Total ** 201